BBS in a Box 5

home *** CD-ROM | disk | FTP | other *** search

/ BBS in a Box 5 / BBS in a Box -Volume V (BBS in a Box) (April 1992).iso / Files / Bus / C / Cat 4 Top 52.cpt / Cat 4 Top 52

Wrap

Text File | 1991-01-31 | 29.0 KB | 713 lines | [TEXT/McSk]

************ Topic 52 Thu Sep 08, 1988 MCLARY at 23:52 PDT Sub: Excel Help WANTED Requests for help, comments and question about Microsoft's Excel spreadsheet application for the Macintosh go here! 91 message(s) total. ************ ------------ Category 4, Topic 52 Message 1 Thu Sep 08, 1988 MCLARY at 23:56 PDT I've been using Excel 1.5 for some time, but now find myself in need of a macro to step users through a data sheet which requires several inputs. Rather than using FUNCTION(INPUT("Please input..."),2) over and over again, thought this would be a good opportunity to use the Dialog Editor to create a minimum number of dialogs for the multiple inputs. Opened Dialog Editor, created some nifty dialogs, selected them, and opened Excel. Yes, there were coordinates and parameters in the clipboard, but can't figure out how to use the Dialog.Box() macro function to invoke the dialogs. I'm sure I read something somewhere, but can't find it now (typical!). Can anyone help me? Thanks in advance...Mike Clary, Mililani HI ------------ Category 4, Topic 52 Message 2 Sun Sep 25, 1988 F.HERPAIN at 01:55 CDT Look on page 181 of the Excel Arrays, Functions & Macros manual. ------------ Category 4, Topic 52 Message 3 Sun Nov 20, 1988 C.HAGBERG1 at 21:45 EST Help is definitely wanted! But I have a more basic problem than macros - I am running (or trying to run) Excel 1.5 undr System 6.0.2 and Finder 6.1. The Excel dialog boxes do not stay on the screen long enough to make a selection! They appear and disappear before they are even fully drawn. Thus, I can't choose "New" for a chart, or even "Save As. . ." Excel 1.5 seems to work fine under my old System 4.2 and Finder 6.0. Any advice/help? Thank much in advance! *S ------------ Category 4, Topic 52 Message 4 Thu Nov 24, 1988 CSF [Chris] at 19:33 PST Haven't encountered that on either a II or a +. But get constant -37 errors on opening; the second time it works fine. That has been like that for at least a year, on several machines. ------------ Category 4, Topic 52 Message 5 Sun Dec 18, 1988 D.WOLOSHYN at 22:07 PST To CSF (Chris)... Your -37 error has been reported (by me, at least) to: Microsoft tech support, Microsoft Excel product manager, and Apple systems enginerrs working on op sys. Thy all say it is some strange and not understood interaction with Mac Op Sys & the way that Excel Launches itself. Also noted on our network is the fact that you can't reliably redict whether a locally mounted Excel or one on a mounted File Server will be launched if you double- click an Excel document. Sorry I can't offer a cure, but rest assured that you are NOT IMAGINING THINGS... ------------ Category 4, Topic 52 Message 6 Mon Dec 19, 1988 A2.DOUG [ManiMAC] at 20:53 EST Hmm..I get that too..I wonder how it works with 6.03b? ------------ Category 4, Topic 52 Message 7 Thu Dec 22, 1988 EPHOTE2 [John Crane ] at 23:43 EST Anybody using auto_open successfully? It will not work for me. Well, actually, it worked once, but the next time I opened the file, it didn't. The macro I'm trying to run is fine. Help, please! ------------ Category 4, Topic 52 Message 8 Fri Feb 10, 1989 JPLINDEMANN at 18:31 EST I am having trouble using DA's either in the DA Handler layer or within EXCEL under the current versions of Multifinder (either with System 6.0.2 or 6.0.3.) If I open Excel, my DA's will not open under the DA handler or within EXCEL. Further, if I open more than one DA prior to opening EXCEL, I get a "-11 error" I guess it could be a problem with Font DA Juggler Plus. Does any one have any ideas? By the way this is using EXCEL v 1.5 on a Mac II with 5 megs of RAM, Apple Color Monitor (256 colors). Documents will print using SuperLaser Spool, but I can't access either the Laser Queue or Chooser! Thanks in advance for any help. ------------ Category 4, Topic 52 Message 9 Fri Feb 10, 1989 DOUG.ACKER [Doug] (Forwarded) Hmmm..it works fine with me with Suticase....try usinging ResEdit and opening up your SIZE resource on the DA Handler. ------------ Category 4, Topic 52 Message 10 Sat Feb 11, 1989 BART.BARTON (Forwarded) I have no problems opening DAs while running Excel on basically the same system as you, Jon. Only difference I can see between us is I'm using SuitCase II rather than Font DA Juggler Plus. I'm not sure what the memory requirements are for SuitCase II vs Font DA Juggler Plus but that appears to be the place to start. ..... Bart ------------ Category 4, Topic 52 Message 11 Sun Feb 12, 1989 W.KAYE1 at 23:28 EST to MCLARY [Mike Clary]: 1) Paste your dialog.box data to your macro sheet by selecting the upper-left corner of the area to be used for its description and selecting Paste. 2) Select the range of cells from that corner to the cell at the bottom row and the seventh (7th) column. Hit Cmd-L and give your dialog.box a short, descriptive name for use as the argument for DIALOG.BOX(name) function. Happy computing! -Walter ------------ Category 4, Topic 52 Message 12 Sun Feb 12, 1989 W.KAYE1 at 23:35 EST to C.HAGBERG1: I have Excel 1.5 running under 6.0.2 normally, but I get that same problem with dialog boxes in Smartcom 2.0. (Red Ryder 9.4 works fine.) I wonder if anyone's found the culprit... ------------ Category 4, Topic 52 Message 13 Sun Feb 12, 1989 W.KAYE1 at 23:46 EST to EPHOTE2 [John Crane]: You say auto_open only worked once? Perhaps the first statement line is no longer defined by that name. Does it work when you select xxx!auto_open from the Macro menu? Try that, if you haven't already done so. ------------ Category 4, Topic 52 Message 14 Thu Apr 20, 1989 RSELKIN at 07:30 EDT Does anyone know if the new 2.0 version will allow you to place charts and text on a spreedsheet similar to Full Impact or Wingz? ------------ Category 4, Topic 52 Message 15 Sun Apr 23, 1989 RSELKIN at 08:19 EDT I left a message recently asking about the upgrade version 2.0. I just saw a demo of this version at Egghead software. However, when I called Microsoft to get some info on this version I was told there was absolutly no information available about a vesion 2.0. Does anyone out there know what is going on with this vapor upgrade? Also I would appreciate it if someone would please respond to my previous question. Thanks in advance Ron Elkin ------------ Category 4, Topic 52 Message 16 Wed Apr 26, 1989 C.BLACKSTONE [Craig] at 20:30 CDT I spoke with someone at MS who thought it would be out in June or so. ------------ Category 4, Topic 52 Message 17 Thu May 04, 1989 MACINFO [Norm Goodger] at 19:22 EDT The May 2 issue of MacWeek has Excel 2.2 touted on the cover. It breaks the 1 meg limit, 40% faster than 1.5, Improved presentation features, cell notes,200 new macro functions, is on the cover. Says its supposed to ship before the end of the 2nd quarter. Other items are multiple fonts & sizes on a sheet, more chart types, macros can access code resources in "C" or pascal, better Quickswitch, AUX 1.1 compatability...thats the latest in the World of Spreadsheets ------------ Category 4, Topic 52 Message 18 Thu May 04, 1989 L.J.KAPLAN [Linda] at 21:09 EDT Yeah, I saw the piece. No color, though. Oh, well. And another steep upgrade fee. --L ------------ Category 4, Topic 52 Message 19 Thu May 04, 1989 JMZIEGLER [J. Marcus] at 20:53 PDT I saw an add for Full Impact (the Ashton Tate spreadsheet) that you could turn in your copy of Excel plus $99 and get Full Impact. I think that $99 is about the same as the upgrade price to Excel 2.2... ------------ Category 4, Topic 52 Message 20 Fri May 05, 1989 DREID at 18:57 EDT But then one'd have to deal with A-T. Thats an 'eel of a choice! ....Dave ------------ Category 4, Topic 52 Message 21 Fri May 05, 1989 DREID at 18:58 EDT That's " 'ell" ------------ Category 4, Topic 52 Message 22 Sun May 07, 1989 C.BLACKSTONE [Craig] at 21:33 CDT I heard on Computer Chronicles that Trapeze is going to be sold direct for either $50 or $90. If it reads Excel files (I assume it does) it might be a cheap way to get some nicer formatting. ------------ Category 4, Topic 52 Message 23 Mon May 08, 1989 NPC.ARCHIVES [Paul Chernof] at 20:55 EDT You can buy Trapeze direct from AccessTechnology for $60 + shipping. It is a nice program but I will not be using it instead of Excel. If you import a spreadsheet it will take alot of time for you to get the formatting which you want. Trapeze works best when you start working in Trapeze. It is good in forcing you to plan your work but is not as good in "quick & dirty" stuff as a regular spread sheet. Something like BASIC vs. Pascal. Paul ------------ Category 4, Topic 52 Message 24 Wed Jun 14, 1989 J.S.FRIEDMAN at 20:38 EDT I'm switching from GS to Mac and have Appleworks SS's I want to use in EXCEL. I don't think EXCEL can deal with AW files directly. IS there anyway to save AW files (i.e. as DIF, or TXT) so that the data and formulas will get transferred? ------------ Category 4, Topic 52 Message 25 Thu Jun 15, 1989 DOUG.ACKER [Doug] at 07:22 EDT You can try DIF format... (but AW's DIF format is a little screwy)....its always worth a try. ------------ Category 4, Topic 52 Message 26 Thu Jun 15, 1989 CSENFT [Craig] at 21:10 MDT if AW's TXT files are tab separated Excel will have no problem. Good Luck! ------------ Category 4, Topic 52 Message 27 Tue Jul 04, 1989 J.S.FRIEDMAN at 14:18 EDT I used a AFE translator found in the libraries here to convert Appleworks files to MS Works files. I don't have MS Works but the description of the file mentioned that Excel (which I do have) reads MS Works files. However, when I select OPEN in Excel, these translated files are nowhere to be seen. Can Excel read MS Works SS's and if so how do I get them in? (*l ------------ Category 4, Topic 52 Message 28 Tue Jul 04, 1989 BART.BARTON at 14:57 EDT I don't believe Excel is capable of directly reading Works files. It's been quite some time since I transferred a spreadsheet created with Works over to Excel but when doing a "Save As" from within Works there's a Normal, Export, and Stationary choice for how the file's saved. Same with going the other way. There's a special file setting within the Save window of Excel to save a file so it can be opened by Works. If you don't happen to know anyone locally who has works, if there are a whole lot which need "translating", if you'll fire them to me via XMODEM E-Mail I've got both Works 2.0a and Excel 1.5 and wouldn't mind changing their formats for 'ya so Excel will recognize the files, if it's not too time consuming. ..... Bart ------------ Category 4, Topic 52 Message 29 Tue Jul 04, 1989 J.S.FRIEDMAN at 16:52 EDT Thanks for the offer. I'll let you know in time if I need you to do that. I I do, there will only be a few of my "key" AW SS's that I converted to MS Works using the translator. 3-4 files all together. ------------ Category 4, Topic 52 Message 30 Tue Jul 04, 1989 BART.BARTON at 18:08 EDT Ah heck, that would be no problem at all to get done! I was afraid maybe we were talking five or six disks full of files. <grin> I could probably get those done in nothing flat and back to 'ya via E-Mail. Just let me know what you'd like to do. ..... Bart ------------ Category 4, Topic 52 Message 31 Wed Jul 05, 1989 DOUG.ACKER [Doug] at 22:42 EDT That translator only works for word processing documents. You might want to convert them toi DIF format and trying translating using the default on AFE and then reading them in with Excel. Worse comes to worse, you can save the AW as text and read them into Excel that way. ------------ Category 4, Topic 52 Message 32 Wed Jul 05, 1989 J.S.FRIEDMAN at 22:46 EDT I did save them as text but they come in a mess. ------------ Category 4, Topic 52 Message 33 Thu Jul 06, 1989 DOUG.ACKER [Doug] at 18:45 EDT Save it as text...and then using something like McSink to change the spaces to tabs... ------------ Category 4, Topic 52 Message 34 Sat Jul 08, 1989 J.HASLUP (Forwarded) I am working on an Excel project, and I have run into a couple problems. I just got my 2.2 upgrade (very nice), and am trying to do a special form in it. I have a form which asks standard information-it's basically a sales sheet that will keep information for clients. What I have a problem with it this: I have a column which is called "Source". In this column I put either "NW" or "CC" (I don't know what they stand for...). Anyhow, at the bottom of the form I have totals of the "Value" column (dollars). Now, below the grand total, I need to have a "NW" and "CC" and "Neither" totals. The grand total is just a SUM of the value column, but for the NW,CC, and OTHER totals, I need to have them add a row ONLY when that row's SOURCE column contains NW (or whichever). Is there ANY way of doing this in excel?? I know it has logic functions, but I'm not that advanced in Excel. I need this form VERY soon, and am VERY stuck! I tried doing this in Hypercard, but the screen is too small for all my needs. Please, does anyone have any ideas? Thanks alot... Jason ------------ Category 4, Topic 52 Message 35 Sat Jul 08, 1989 LINDA.KAPLAN at 23:56 EDT There is absolutely a way to do it in Excel. It would start something like "=IF(" without the quotes. Well, it's probably a little more complicated. It would be a SUM and one of the SUMs would contain the conditional statement. You should be able to get help from MICROSOFT on how to do this, since you're a registered owner. They have a forum here. Just type "microsoft" at the appropriate prompt. I was actually just brushing up on this, because I'm a consultant and have a banker client who wants an Excel lesson on Wednesday. I'm sure you can do what you want in Excel. It' s very powerful. --L ------------ Category 4, Topic 52 Message 36 Sun Jul 09, 1989 D.WOLOSHYN at 20:31 PDT Jason/ Linda- If you can't do what you you want in a single cell, you can write a "function macro" to put values in a cell. With Excel's "auto-execute" macro capability, the user doesn't even have to load a macro manually. Drew... ------------ Category 4, Topic 52 Message 37 Fri Aug 18, 1989 J.KRELL1 at 21:05 EDT Does anyone know how to get MenuFonts 2.02 to work with Excel 2.2? Jay {*s ------------ Category 4, Topic 52 Message 38 Tue Sep 12, 1989 J.LEWIS5 at 21:32 EDT OK! OK! I know I should have written it down ... BUT ... I didn't! Is there anyone out there who knows how to unlock an Excel 1.5 or 2.2 Password Protected file. We (me) protected a Template - and now we have about 100 protected (REALLY protected) files. I will gladly listen to any quantity of public ridicule from the individual that can H E L P M E ! ! ! ! please! signed 'The Jerk in Jersey, Jeff' ------------ Category 4, Topic 52 Message 39 Thu Sep 14, 1989 MACINFO [Norm Goodger] at 02:10 EDT From what I understand, if you lost the password, its all over... ------------ Category 4, Topic 52 Message 40 Wed Oct 11, 1989 R.LENZA1 at 19:04 EDT I need some help/guidance. I've been given the task of setting up some spreadsheets on the Mac using EXCEL. I'm having a minor(?) problem and I don't know if it's due to my unfamiliarity with the Mac or the program. Anyway, whats the trick to using EXCEL from a hard drive? I've got it copied on to the drive OK, and it works fine as long as I load EXCEL first, and then open a document. However, just double clicking an icon (which is what I presumed I should be able to do on a Mac) produces a message that states "the application is either busy or missing". Double clicking does work with EXCEL in the floppy drive, but it sure seems a slow way to do things with a hard drive right there. The setup is a Mac Plus with an EMAC's hard drive, using EXCEL version 1.5 (I think; I forgot to write it down before I came home). Any pointers would be greatly appreciated. THANKS, ROY ------------ Category 4, Topic 52 Message 41 Wed Oct 11, 1989 DOUG.ACKER [Doug] at 22:46 EDT If you are using MultiFinder..its a MultiFinder feature.... ------------ Category 4, Topic 52 Message 42 Wed Oct 11, 1989 CSF [Chris] at 22:06 PDT You need to rebuild your tesktop. On rebooting, hold down option and cmd keys until you see a dialogue box. By the way, you should probably upgrade: the current version is 2.2, and is a considerable improvement. You can still open the spreadsheets from within excel even if you don't rebuild the desktop, though. ------------ Category 4, Topic 52 Message 43 Sat Oct 21, 1989 R.SIGMON [Rodney] at 11:43 EDT A few people mentioned Excel 2.2 crashes, possibly caused by Moire, so maybe someone can help me. I've recently upgraded to Excel 2.2, and had serious problems getting it to work. When I first installed it on my Mac II, it would work fine as long as I didn't click in the Menu Bar, or use Excel's alternate Menu system. Then, (under Multifinder) I would get the "unexpectedly quit" message. Under the Finder I would get a System bomb (28 I think). If I kept trying I would get screen freezes or the screen would go to complete static or snow. I eventually had to trash my System Folder completely and reinstall it. Running the Installer didn't help. Neither did removing all my inits. Microsoft said it was an Init conflict, but couldn't tell me what Init. (I was able to replace all my Inits afterwards, and everything worked) Before I installed Excel on our Plus, I ran the Installer, hoping that would help. And it seemed to, for about a month. Then I got the same problems. When I tried to put Excel on my SE, running the Installer first didn't help. I was not using Moire on my Mac II at the time, though I later changed to it. I was using Pyro then. I was also using Pyro on the Plus, though I think I switched between the time I installed it and the time it crashed. I WAS using Moire on my SE. Here is a list of the Inits I think I had on all three Macs. INITMANAGER 1.0B1 Startupscreen SoundInit-this didn't work on the Mac II, but I tried to install it so that may have done something. I have many other Inits, but none common to all my Macs. I am currently using System 6.0.3. Can anyone help? I don't want everything to crash a month from now. ...Rodney... (I ALSO POSTED THIS MESSAGE IN CAT. 5, TOPIC 43) ------------ Category 4, Topic 52 Message 44 Fri Oct 27, 1989 CHERNOFF [Paul] at 20:23 EDT Make sure that you are using the very latest version of Moire. Earlier versions have problems with Excel 2.2. The latest version seems to have no conflict (and this is on a Mac II running system 6.03). Paul ------------ Category 4, Topic 52 Message 45 Mon Oct 30, 1989 D.WOLOSHYN at 20:55 PST Paul- Do you know what the "very latest" version of Moire is? Thanks, Drew... ------------ Category 4, Topic 52 Message 46 Wed Jan 10, 1990 STEVE.KAHN at 20:47 PST I've run into a small glitch with Excel 2.2, running on a Mac Plus with 1M and System 6.02. I have a "workspace" group of about 5 files with a number of links between them. After I've been working for a while, many of the menu commands stop working. For example, if I pull down the Format menu and select an option such as "Number" or "Define Name," nothing happens, no dialog box. No messages, crashes, etc. I can still select cells, enter data, calculations seem to work. So far, if I Save, Quit and reopen my workspace, everything works again. Has happened twice. When it happened this morning, I realized that I had printed to my ImageWriter a short time before, so that's one possibility. Not a big deal...so far, but irritating and perplexing. Any ideas? ------------ Category 4, Topic 52 Message 47 Fri Jan 12, 1990 MACINFO [Norm Goodger] at 19:39 EST Is this with 2.2a? I am not sure if your problem is related specifically to fixes within the 2.2a release, but it might be worth looking into. Perhaps a note in the MS RT? ------------ Category 4, Topic 52 Message 48 Fri Jan 12, 1990 LINDA.KAPLAN at 22:43 EST One Excel file on which I'd spent some time suddenly wouldn't open, be read and much was lost and garbaged. I called MS and they explained that 2.2 doesn't work on partitions (only on the boot partition)! Then they offered to send me the free fix: 2.2a. Boy, was I steamed. This policy (Silicon Beach does it, too, as do many many other reputable companies) of deciding that few people will be effected, so not notifying owners of the fix until after they are burned, really burns _me_ up. --L ------------ Category 4, Topic 52 Message 49 Sat Jan 13, 1990 DOUG.ACKER [Doug] at 08:50 EST Of course one can order order v2.2a two months ago and not recieve it..... ------------ Category 4, Topic 52 Message 50 Sat Jan 13, 1990 LINDA.KAPLAN at 17:48 EST Mine took a while to get to me, but not that long. I didn't use the regular Customer Relations number for the upgrade. I had called Tech Support, a Toll Call, and spent forever on the phone trying to salvage the mangled file. When he told me about 2.2a, he wanted me to call the toll-free other number, but I pushed for him to do it. I don't know why. I don't think I consciously suspected it would take longer the other way. I didn't feel like having to make another call, possibly wait a long time on hold, deal with another person. He had my info on his screen, so I asked him to send it out to me. The disk was rolling around FedEx for ages though. It might have taken a month to get to me. --L ------------ Category 4, Topic 52 Message 51 Sat Jan 13, 1990 DOUG.ACKER [Doug] at 18:48 EST I went through Debbie online here.....she's pretty good...too bad she is leaving MS ------------ Category 4, Topic 52 Message 52 Sun Jan 14, 1990 LINDA.KAPLAN at 06:30 EST That is too bad. She has helped me in the past. --L ------------ Category 4, Topic 52 Message 53 Tue Jan 16, 1990 CLAGRAPH [David] at 23:11 EST My wife is helping a friend of hers input some data into Excel. I know nothing of the program so I am asking for some help to keep her from complaining every time she uses the program. Apparently her friend has set up a "form" that she has to fill out for each complete entry, about six or seven "fields" of information. Her complaint is that she HAS to use the Tab key to advance to the next field. She would rather use the carriage return (or enter) key but this advances to the next record. If this were a DOS computer I would just use Superkey and remap the enter key as the tab key and it would be fixed. How is this done on a Mac? Can it be done in Excel itself? David ------------ Category 4, Topic 52 Message 54 Wed Jan 17, 1990 DON.PEASLEE at 11:37 EST One method would be to use QuicKeys to remap the keyboard just as you mentioned you would do with Superkey. Just use the QuicKey "alias" function. If, by chance, you don't have QuicKeys; get it immediately. It's worth its weight in gold. Don ------------ Category 4, Topic 52 Message 55 Wed Jan 17, 1990 PHOTOBASE2 [John Crane] at 20:49 EST I use the cursor keys for moving in any direction...simply have them defined as aliases for tab and shift tab. ------------ Category 4, Topic 52 Message 56 Sat Feb 17, 1990 PHOTOBASE at 17:11 EST Sorry to jump in like this, but please allow me to ask a simple question. I am setting up a small worksheet and am using a simple formula something like =ROUND(A5/C5,0) but get a NUM! error message unless there is data in one of the cells. What is the best way to get rid of the error message? ------------ Category 4, Topic 52 Message 57 Sat Feb 17, 1990 DOUG.ACKER [Doug] at 22:10 EST Keep a number in one of the cells ::grin::.... ------------ Category 4, Topic 52 Message 58 Sun Feb 18, 1990 PHOTOBASE at 14:19 EST Gee Doug....I never thought of that.... ANY OTHER solutions? ------------ Category 4, Topic 52 Message 59 Mon Feb 19, 1990 DOUG.ACKER [Doug] at 00:57 EST How about putting a @NA in the cells? Or a If statement...if the cells are empty, put a 0, else...do your calculation ------------ Category 4, Topic 52 Message 60 Mon Feb 19, 1990 PHOTOBASE at 23:50 EST Thanks, I will try .... =IF(A1>0,Formula,"") ------------ Category 4, Topic 52 Message 61 Tue Mar 06, 1990 A.BORCHERS at 19:51 CST Can someone give me a hand in setting up formulas in Excel 2.2 that would help . 1) S1 - (RATIO * S2) = RESULT1 2) S1^2 + (RATIO * S2^2) = RESULT2 . I can enter the formulas to display the RESULT values based on manually entered trial and error values, but I want Excel to automatically calculate the values rather than working with trial and error. The knowns I start with are the RESULT values and the RATIO value. For example the trial problem I am ate unknowns are S1=46 and S2=44.5. The RATIO = .606, RESULT1 = 19.0 and RESULT2 = 3315. . Please respond via E-Mail as I can t always get online as often as I like. . Art Borchers CompuServe: 76344,26 GEnie: A.Borchers /exit ------------ Category 4, Topic 52 Message 62 Tue Mar 06, 1990 E.BLOOM at 23:00 EST I was wondering if someone can tell me if what I want to do in Excel is very difficult or easy or anywhere in between. I am trying to create a sales summary report similar to the one in my office on the pc using dbase. I have been able to load in the database as text, and being a novice with excel, I don't know if I am attempting the impossible. Basically, with 5 salespeople, and ten sales a month per salesperson, I 'd like a report with the salesperson's names on the left column, the months going across the top, and the TOTAL(sum) for each salespersons ten sales in the respective month. Any help or recommendations are aapprecitated. Rick Bloom ------------ Category 4, Topic 52 Message 63 Wed Mar 07, 1990 PHOTOBASE at 00:17 EST Rick what you want to do is somewhat easy. In such cases, I will normally use a data entry area and report area. The entry is for the data and will manipulate it to report for nice printing. Your entry will be five names with ten report cells per month or 50 cells in a column, then 12 columns. To Total, click in each of the ten cells then FILL right. OR use the SUM function. Then Report that sum to a cell that IDs the name and month. If you use a DATE function, and save the printouts, you can track the sales as the month progresses. Look at the SUM, AVG and DATE functions. Then look in the manual to see how to have one cell report to another. If you need more help, let me know. Sparks ------------ Category 4, Topic 52 Message 64 Wed Mar 07, 1990 E.BLOOM at 22:25 EST Thanks for the advice. When you say " your entry will be five names" are you referring to the data entry area or the report area? Also, I presume the ten report cells are in the report area you described. I am encouraged by the fact that you say it is somewhat easy. Well, it may be easier for you! But now I know the time I spend creating the worksheet will pay off. Thanks again, Rick ------------ Category 4, Topic 52 Message 65 Thu Mar 08, 1990 PHOTOBASE at 00:33 EST Ok.... yes the entry area will have five areas titled by your sales people, and each person's area is ten cells long. (10 sells per month per salesperson?) And no, the entry area would be the ten cell area, you COULD report the total sales and avg sales to just 2 cells per sales person per month to the REPORT area. Sparks ------------ Category 4, Topic 52 Message 66 Sat May 05, 1990 C.FARIA at 10:34 CDT PLEASE HELP !!!!!!!! I am fairly new to spreadsheets and after giving up on wingz (though I am hypercard/text literate) I have a simple but very confu sing problem (to me). All I want to do is write a macro where I can select a cell (that has a number in it), then have an input box come up, ask me what number I want to add to the selected cell, then have the macro add the two together. In effect I can select cells, and have the macro add them. For the life of me I can't figure it out. I know simple, right? Anyone?? ------------